← Return to doc.sitecore.com

Porting MSSQL database to MSDE
Print this page (opens in new window) Print

The following procedure may come in handy when you need to port your database from the full MSSQL installation to MSDE.

 

You should perform the next steps:

  1. Create a backup of the each database. See the image below.
  2. Restore the backup of each site in MSDE. You can use the SQL Server Enterprise Manager or usual SQL script for the purpose, e.g.: 

1.  Sample Script

 1 RESTORE DATABASE scArchive FROM DISK = 'C:\Inetpub\SiteCore\SITECORE_ALLSITES\Ducat5.0.7.3\ARC\scArchive.bak' WITH MOVE 'scCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_DatascArchive.MDF' , MOVE 'scCore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_LogscArchive.MDF' ; 
 2 
 3 RESTORE DATABASE scCore FROM DISK = 'C:\Inetpub\SiteCore\SITECORE_ALLSITES\Ducat5.0.7.3\ARC\scCore.bak' WITH MOVE 'scCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_DatascCore.MDF' , MOVE 'scCore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_LogscCore.MDF' ; 
 4 
 5 RESTORE DATABASE scExtranet FROM DISK = 'C:\Inetpub\SiteCore\SITECORE_ALLSITES\Ducat5.0.7.3\ARC\scExtranet.bak' WITH MOVE 'nextOT_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\nextOT_DatascExtranet.MDF' , MOVE 'nextOT_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\nextOT_LogscExtranet.MDF' ; 
 6 
 7 RESTORE DATABASE scMaster FROM DISK = 'C:\Inetpub\SiteCore\SITECORE_ALLSITES\Ducat5.0.7.3\ARC\scMaster.bak' WITH MOVE 'scCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_DatascMaster.MDF' , MOVE 'scCore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_LogscMaster.MDF' ; 
 8 
 9 RESTORE DATABASE scRecycleBin FROM DISK = 'C:\Inetpub\SiteCore\SITECORE_ALLSITES\Ducat5.0.7.3\ARC\scRecycleBin.bak' WITH MOVE 'scCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_DatascRecycleBin.MDF' , MOVE 'scCore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_LogscRecycleBin.MDF' ; 
10 
11 RESTORE DATABASE scSecurity FROM DISK = 'C:\Inetpub\SiteCore\SITECORE_ALLSITES\Ducat5.0.7.3\ARC\scSecurity.bak' WITH MOVE 'nextOT_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\nextOT_DatascSecurity.MDF' , MOVE 'nextOT_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\nextOT_LogscSecurity.MDF' ; 
12 
13 RESTORE DATABASE scWeb FROM DISK = 'C:\Inetpub\SiteCore\SITECORE_ALLSITES\Ducat5.0.7.3\ARC\scWeb.bak' WITH MOVE 'scCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_DatascWeb.MDF' , MOVE 'scCore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\scCore_LogscWeb.MDF' ;

Of course, you should change the paths to your own.